﻿create table tbl_SendMessageLog
(
   ProviderName nvarchar(40),
   Mobile varchar(200),
   [Message] nvarchar(500),
   [Status] int,
   IsSuccess bit,
   ErrorMsg nvarchar(200),
   SendDt TIMESTAMP default (datetime('now', 'localtime')) 
)


create table tbl_ReceiveMessageLog
(
  ProviderName nvarchar(40),
  Mobile varchar(20),
  [Message] nvarchar(140),
  ReceiveDt datetime
)